Today's Question:  What does your personal desk look like?        GIVE A SHOUT

SEARCH KEYWORD -- Safe font



  LEFT OUTER JOIN with ON condition or WHERE condition?

The difference is subtle, but it is a big difference. The ON condition stipulates which rows will be returned in the join, while the WHERE condition acts as a filter on the rows that actually were returned.Simple example: Consider a student table, consisting of one row per student, with student id and student name. In a second table, a list of grades that students have received, with student_id, subject, and grade. Give me a list of all students, and show their grade in Math. This requires a LEF...

   SQL,Outer jo0in,On,Where,On vs where,where vs on     2011-11-01 02:04:29

  Helping people find good Perl tutorials

If a co-worker comes to you and asks you: "I would like to learn Perl, where can I find a good Perl Tutorial?", I am sure your would have a few recommendations. If the same person did not know you she would have to type some search term in Google and hope she found the right learning material.Recently Christian Walde (Mithaldu) asked "How do newbies find Perl learning materials online?". Dave Cross responded by checking the top results when searching for "perl tutorial".It shows that many p...

   Perl,Perl tutorial,Resource,Website     2011-11-03 13:34:33

  ASP.NET 4 Breaking Changes #1: requestValidationMode cause ValidateRequest=False to fail

The request validation feature in ASP.NET provides a certain level of default protection against cross-site scripting (XSS) attacks. In previous versions of ASP.NET, request validation was enabled by default. However, it applied only to ASP.NET pages (.aspx files and their class files) and only when those pages were executing.In ASP.NET 4, by default, request validation is enabled for all requests, because it is enabled before the BeginRequest phase of an HTTP request. As a result, request valid...

   ASP.NET,Html content,Error,ValidateRequest,requestValidationMode     2011-11-07 13:50:29

  The Programmer Salary Taboo

Salary is an interesting topic. It's certainly one everyone has an opinion on. It's also a uniquely taboo subject among members of the working public. Since I'm about a month away from being done with University and entering the programmer workforce, I've taken to asking my classmates what type of starting salaries they're getting at their first jobs. The first thing I discovered is that not everybody is very comfortable with this question, and many companies are even less so. Microsoft requests...

   Salary,IT company,Taboo,Google,Microsoft     2011-04-18 00:19:03

  Small team? Fix your life with a non-virtual assistant

Like many others, I tried “outsourcing my life” using a digital assistant. A year and a thousand bucks later, I’ve received one department store recommendation and an admittedly adequate spreadsheet of competitive research.I have since cancelled. Why didn’t it work for me?I think I just didn’t trust it/them/him/her (that I even have this ambiguity is indicative of the issues).Most of my mindless time-sinks involve at least a credit card number and are often a con...

   Work,Assistant,Team,Small,Individual,Get an assistant     2011-10-28 10:26:36

  Beauty of front end--List of front end tools used by GitHub

I did this summarization when I added Lirate_CoffeeScript support for GitHub-Linguist, i.e how does GitHub do Marjdown render and code highlight in its front end. Lots of font end tools used by GitHub are open sourced. They are: 1. HTML/CSS/JavaScript 1.1 HTML template GitHub markup and template styleguide : https://github.com/styleguide/templates 1.2 Style and CSS GitHub uses replacement of CSS: SCSS:https://github.com/nex3/sass KSS:https://github.com/kneath/kss GitHub CSS styleguide ...

   GitHub, front end,Tool     2013-03-07 03:46:42

  Using an Image Submit Button within an HTML Web Page Form

If you're using an HTML form on your web site and would like to use an image submit button instead of the boring standard submit button, this HTML code is for you.In order for your form's input box and your image submit button to line up properly, you will need to place it within an HTML table. In addition, unless your image has a transparent background, you will need to set the table background color to the same color as the image background so that it will seamlessly b...

   Submit button,Image,Html     2011-10-02 12:17:01

  Is coding going to die?

There is always a voice recent years saying that coding will gradually die, software development is more like an assembly job. i.e, programmer will be more and more like IT engineers. They seldom build something from scratch, instead they achieve the goal by assemble different components. There are people who have similar views around me. From the book "Clean code" written by Robert C Martin-- "One might argue that a book about code is somehow behind the times—that code is no longer...

   Coding,Clean code,Disappear,Analysis     2012-03-15 14:37:35

  Net Neutrality is Dead - and Web Development Will Never Be The Same Again

Against the wishes of web users and tech businesses alike, the FCC has pushed through regulations to kill net neutrality. Here’s what that means for web developers. On December 14, 2017, the FCC voted in a 3-2 decision to roll back the Obama administration’s 2015 net neutrality rules. These policies, which demanded stronger oversight for broadband companies and internet service providers, ensured that all data on the web was treated equally. Most importantly, they prevented web traf...

       2019-05-02 21:55:53

  Setting server timezone

To set your web servers date timezone, for example for Eastern Standard Time (EST) use the following code:SetEnv TZ America/IndianapolisFor example, for Los Angeles time (Pacific time), use the following code:SetEnv TZ America/Los_AngelesOther location examples include:America/New_York - Eastern Time America/Detroit - Eastern Time - Michigan (most locations) America/Louisville - Eastern Time (Louisville, Kentucky) America/Indianapolis - Eastern Standard Time (Indiana, most locatio...

   .htaccess,Server,Time zone,Change     2011-10-03 14:45:33